In Crystal Reports, nesting means to use one If
Null means there is no value within a database field for a given record. It does not mean zero because zero is a value.
A null string is an empty string. It contains no characters. If you were to use the Count function to count the string, it would return a length of zero. "" is used to designate a null string.
Numeric data is data on which you can perform arithmetical calculations. The designation numeric refers to the way the data is treated by Crystal Reports and database programs, not to the way the data looks to you.
For example, a serial number 12345 looks numeric, that is, every character is a number. But a serial number is not the kind of data on which you would want to perform arithmetic, so you would probably store a serial number as text instead of as numeric data.
Numeric is one of several data types. Database programs require you to designate a data type when you create a field for use in a database. The data type you select determines the rules the program follows when dealing with the values stored in that field.
Seagate Software IMG Holdings, Inc. http://www.seagatesoftware.com Support services: http://support.seagatesoftware.com |